CD Schooolhouse Version 10.0

home *** CD-ROM | disk | FTP | other *** search

/ CD Schooolhouse Version 10.0 / CD Schooolhouse Version 10.0.ISO / pc / dos / math / think / think.hlp < prev next >

Wrap

Text File | 1994-05-18 | 7.9 KB | 214 lines

The Thinker Help Screens @1,Summary of Functions @2,Mathematical functions @3,Statistical functions @4,Financial functions @5,Special functions @6,Features of The Thinker @7,Command sequences @8,Worksheet options @9,Print options @10,"HOW TO" @11,"How to become a registered user" ##1 Available Functions NOTE:Some arguments may be ranges such as A1.B3, or numbers. When a range or a list of arguments may be used, LIST is given in the function description. If the function takes only a single argument "arg" will be designated. Mathematical Functions Statistical Functions ---------------------- --------------------- @ABS(arg) @LN(arg) @AVG(list) @SS(list) @ACOS(arg) @LOG(arg) @COUNT(list) @STD(list) @ASIN(arg) @MOD(x,y) @MAX(list) @SUM(list) @ATAN(arg) @PI @MIN(list) @VAR(list) @ATAN2(arg) @RAND @SEM(list) @COS(arg) @ROUND(x,n) @EXP(arg) @SIN(arg) Financial Functions @INT(arg) @SQRT(arg) ----------------------- @TAN(arg) @FV(pmt,int,term) @IRR(guess,list) Special Functions @NPV(x,list) ---------------------- @PMT(prn,int,term) @ERR @DEC(arg,n) @PV(pmt,int,term) ##2 Mathematical Functions ---------------------- @ABS(arg) - absolute value @ACOS(arg) - arc cosine @ASIN(arg) - arc sine @ATAN(arg) - 2 quadrant arc tangent @ATAN2(arg)- 4 quadrant arc tangent @COS(arg) - cosine @EXP(arg) - exponential @INT(arg) - integer part @LN(arg) - log base e @LOG(arg) - log base 10 @MOD(x,y) - x modulo y @PI - pi („) @RAND - random number between 0 and 1 @ROUND(x,n)- round a number to n decimal places @SIN(arg) - sine @SQRT(arg) - square root @TAN(arg) - tangent ##3 Statistical Functions --------------------- @AVG(list) - average or items in list @COUNT(list) - counts number of items in list @MAX(list) - maximum of values in list @MIN(list) - minimum of values in list @SEM(list) - standard error of the mean from list @SS(list) - sum of sqaures from list @STD(list) - standard deviation from list @SUM(list) - sum of numbers in list @VAR(list) - variance of numbers in list ##4 Financial Functions ----------------------- @FV(pmt,int,term) - FUTURE VALUE OF AN ANNUITY pmt = payment made each period int = interest per period; term = number of periods @IRR(guess,list) - INTERNAL RATE OF RETURN guess = initial guess (usually 0 to 1.) list = cash flows @NPV(x,list) - NET PRESENT VALUE x = per period interest rate list = cash flows @PMT(prn,int,term) - MORTGAGE PAYMENT PER PERIOD prn = beginning principle int = per period interest rate term = how many payments to be made @PV(pmt,int,term) - PRESENT VALUE OF AN ORDINARY ANNUITY pmt = payment per period int = interest per period; term = number of periods ##5 Special Functions ----------------- @ERR - designates a value of ERR (error). A cell with value ERR will cause subsequent functions to return a value of ERR. @DEC(x,n) - causes the number associated with the cell to print out the number to n decimal places. ##6 Features of The Thinker ----------------------- Size of worksheet - 26 columns lettered A to Z 125 rows Maximum number of cells defined at one time = 1000 Calculations are performed in natural sequence. That is, a calculation does not take place until all previous cells which related to that cell have also been calculated. All files to be accessed must be in the same sub-directory. ##7 Command Sequences ----------------- All commands are invoked by first typing the slash "/" character. A menu will then be presented: Worksheet Range Copy Move File Print Quit To choose one of these options, press the first letter of the option, or move the selection marker by pressing the space bar, then press ENTER when the desired options is highlighted. Another menu, or a question may then appear on the screen. -WORKSHEET - options having to do with the entire worksheet (Global, Insert, Delete, Column-Width, and Erase) -RANGE - Erase a range of cells -COPY and MOVE - Copy or move a range of cells -FILE - Save or Retrieve a file, or list files on disk -PRINT - Print a worksheet to a file or to the printer. -QUIT - End the program ##8 Worksheet Options ----------------- -GLOBAL - Set global column-width, or choose manual or automatic calculation -INSERT - Insert blank columns or rows -DELETE - Delete column or rows -COLUMN-WIDTH - Set or Reset column width of a specific column -ERASE - Erase the entire worksheet ##9 Print Options ------------- -RANGE - Select range of worksheet to print -LINE - Print a single blank line on the page -PAGE - Go to top of page -CLEAR - Clear the print selections -ALIGH - Align the paper -GO - Begin printing -QUIT - Quit the print procedure -SETUP - Send printer a setup code ##10 HOW TO HOW TO QUIT - When you return to the worksheet screen, press the slash key "/". The menu will appear. Next press the "Q" key. You will be given one more "Yes No" choice. If you wish to stop the program, press the "Y" key. HOW TO SAVE A FILE - Press "/", then choose "F" for FILE. Choose "S" for SAVE. Next enter a name for your worksheet, using eight or fewer characters. HOW TO GET A FILE BACK - Press "/", then choose "F" for FILE. Choose "R" for RETRIEVE. Next enter the name of the file to get. If you don't know the name of the file, see next "How to". HOW TO GET A LISTING OF FILES ON DISK - Press "/", then choose "F" for FILE. Next choose "L" for list. You will be asked to specify either THINKER files or all files. Choosing THINKER will list all files with the ".TKR" extension. ##11 The THINKER program is a copyrighted program that allows users, under certain conditions, to copy and share the program with others. Never call it a "public domain" program. You are not allowed to make photocopies of the manual. Persons who use THE THINKER are obliged to become officially licensed users by registering. This provides you with several advantages. You receive information about new releases, bugs, updates and problems. You also get a copy of the latest version of the program and manual on disk. If you use THE THINKER, you should print the ORDER form on disk, and become a registered user. To print the file named ORDER, with the THINKER disk in the A drive, use the command: A>COPY ORDER LPT1: Thanks. ORDER, with the THINKER disk in the A drive, use the command: A>COPY ORDER LPT1: